package iglesia.invimosa.lyrics.manager.datalayer;

import java.sql.ResultSet;
import java.util.ArrayList;

public interface LyricsManagerOperations {
	
	//Get Statements
	public ResultSet getLyricsFromSongName(String songName);
	public ResultSet getSongsFromType(String songType);
	public ResultSet getSongsByArtist(String artist);
	public ResultSet getSongByName(String name);
	public ResultSet getListOfArtists();
	public ResultSet getAllSongTypes();
	public ResultSet getReproductionList(String listName);
	public int getListId(String listName);
	public int getSongId(Songs song);
	public int getSongId(String name);
	public int getArtistId(String name);
	public int getSongTypeId(String name);
	public String getSongType(String songName);
		
	//Insert Statements
	public boolean insertNewSong(String songName,
			int songType,
			int artist,
			String Lyrics,
			ArrayList<String> tags);
	public int insertArtist(String artistName);
	public boolean insertSongType(String songType);
	public boolean createNewList(String name, ArrayList<Songs> songs);
	
	//Modify Song Name
	public boolean modifySongName(int id, String newName);
	public boolean modifyArtistName(int id, String newName);
	public boolean modifySongTypeName(int id, String newName);
	
	//Delete Statements
	public boolean deleteSong(String song, String artist);
	public boolean deleteListOfReproduction(int listId);
	public boolean deleteArtist(int artistId);
}
